package factory.one.entity;

import java.util.Date;

//发货单 细项
public class DeliverItem {

    private Long id;
    private Long deliverId; //发货单ID
    private Long batchId; //产品批次ID
    private Integer number; //发送数量
    //for view
    private String productName; //前端展示

    public static final String CREATE_SQL = "    create table DELIVERITEM (\n" +
            "        ID bigint not null GENERATED ALWAYS AS IDENTITY,\n" +
            "        DELIVER_ID bigint not null,\n" +
            "        BATCH_ID bigint not null,\n" +
            "        NUMBER int not null,\n"+
            "        primary key (ID)\n" +
            "    )";

    public static final String INDEX1_SQL = "CREATE INDEX idx_deliver on DELIVERITEM (DELIVER_ID)";

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public Long getDeliverId() {
        return deliverId;
    }

    public void setDeliverId(Long deliverId) {
        this.deliverId = deliverId;
    }

    public Long getBatchId() {
        return batchId;
    }

    public void setBatchId(Long batchId) {
        this.batchId = batchId;
    }

    public Integer getNumber() {
        return number;
    }

    public void setNumber(Integer number) {
        this.number = number;
    }

    public String getProductName() {
        return productName;
    }

    public void setProductName(String productName) {
        this.productName = productName;
    }
}
